﻿
IF object_id(N'dbo.[UDS_SMS_MobileMsgSendBuffer]', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_SMS_MobileMsgSendBuffer] (
        [MsgID]             numeric(18,0) NOT NULL identity(1, 1),
        [Sender]            nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [RecipientMobileNo] nvarchar(20)   COLLATE Chinese_PRC_CI_AS NULL,
        [Content]           nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
        [SendTime]          datetime      NULL CONSTRAINT [DF_UDS_SMS_MobileMsgSendBuffer_SendTime] default((getdate())),
        [RepeatTimes]       int           NULL CONSTRAINT [DF_UDS_SMS_MobileMsgSendBuffer_RepeatTimes] default(((0))),
        [RepeatPeriod]      int           NULL,

        CONSTRAINT [PK_UDS_SMS_MobileMsgSendBuffer] PRIMARY KEY CLUSTERED ([MsgID] asc)
    );
END
GO
